Re: [GENERAL] Why are my index files are much larger than my datafiles

Michael J Davis <michael.j.davis@tvguide.com> wrote:
>...
>The first index is three int4 values.  The second index is one int4 value.
>Why are the index files so large?  What can I do to reclaim the disk space.
>This is after a vacuum.  PostgreSQL 6.5 as of 4/25/99.   Red Hat 5.1 intel
>pentium II.

You could do a drop index followed by a create index followed by a vacuum.

-- Ari Halberstadt mailto:ari@shore.net <http://www.magiccookie.com/>
PGP public key available at <http://www.magiccookie.com/pgpkey.txt>